﻿CREATE TABLE [dbo].[ManagementArea] (
    [Id]             INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [zid]            VARCHAR (200)   NULL,
    [CompanyName]    NVARCHAR (50)   CONSTRAINT [DF_Zzjg_xx_CompanyName] DEFAULT ('') NULL,
    [Startletter]    NVARCHAR (50)   CONSTRAINT [DF_Zzjg_xx_Startletter] DEFAULT ('') NULL,
    [CompanyPhone]   NVARCHAR (50)   CONSTRAINT [DF_Zzjg_xx_CompanyPhone] DEFAULT ('') NULL,
    [CompanyFax]     NVARCHAR (50)   CONSTRAINT [DF_Zzjg_xx_CompanyFax] DEFAULT ('') NULL,
    [CompanyAddress] NVARCHAR (200)  CONSTRAINT [DF_Zzjg_xx_CompanyAddress] DEFAULT ('') NULL,
    [Zip]            NVARCHAR (50)   CONSTRAINT [DF_Zzjg_xx_Zip] DEFAULT ('') NULL,
    [ContactPerson]  NVARCHAR (50)   CONSTRAINT [DF_Zzjg_xx_ContactPerson] DEFAULT ('') NULL,
    [ContactPhone]   NVARCHAR (50)   CONSTRAINT [DF_Zzjg_xx_ContactPhone] DEFAULT ('') NULL,
    [ContactEmail]   NVARCHAR (50)   CONSTRAINT [DF_Zzjg_xx_ContactEmail] DEFAULT ('') NULL,
    [WebAddress]     NVARCHAR (50)   CONSTRAINT [DF_Zzjg_xx_WebAddress] DEFAULT ('') NULL,
    [Products]       NVARCHAR (2000) CONSTRAINT [DF_Zzjg_xx_Products] DEFAULT ('') NULL,
    [CompanyNumber]  VARCHAR (50)    CONSTRAINT [DF_Zzjg_xx_CompanyNumber] DEFAULT ((0)) NULL,
    [flag]           INT             CONSTRAINT [DF_ManagementArea_flag] DEFAULT ((0)) NULL,
    CONSTRAINT [PK_ManagementArea_1] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'关联组织架构ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'zid';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'CompanyName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'开头字母', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'Startletter';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'电话', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'CompanyPhone';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'传真', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'CompanyFax';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'地址', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'CompanyAddress';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'邮编', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'Zip';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'联系人', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'ContactPerson';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'联系电话', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'ContactPhone';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'邮箱', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'ContactEmail';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'网址', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'WebAddress';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'经营项目', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ManagementArea', @level2type = N'COLUMN', @level2name = N'Products';

